create external table jms_dm.dm_terminal_tran_direct_delivery_send_sum_dt 
(
end_provider_id           string COMMENT '省份id' ,
end_provider_name         string COMMENT '省名字' ,
end_agent_code            string COMMENT '代理区code' ,
end_agent_name            string COMMENT '代理区名字' ,
end_center_code           string COMMENT '末端中心code' ,
end_center_name           string COMMENT '末端中心名字' ,
end_city_id               string COMMENT '城市id' ,
end_city_name             string COMMENT '末端城市' ,
end_area_id               string COMMENT '末端区县id' ,
end_area_name             string COMMENT '末端区县' ,
final_sign_network_code   string COMMENT '规划签收网点code' ,
final_sign_network_name   string COMMENT '规划签收网点' ,
package_type              string COMMENT '包类型' ,
second_package_code       string COMMENT '二段吗' ,
third_package_code        string COMMENT '三段码' ,
waybill_sum               int COMMENT '运单量' ,
package_sum               int COMMENT '包数' ,
third_code_right_sum      int COMMENT '三段码准确的量' ,
arrival_send_sum          int COMMENT '一键到出量' ,
aging_sign_sum            int COMMENT '准点签收量' ,
ass_sum                   int COMMENT '错分量' ,
send_noarrival_sum        int COMMENT '有发无到总量' ,
center_send_sign_hours    string COMMENT '中心发发件时间到时效签收时间' ,
no_send_sign_cnt          int COMMENT '发签缺失量' ,
deliver_sign_hours        string COMMENT '派签时长' ,
deliver_sign_loss_cnt     int COMMENT '派签缺失量' ,
date_time                 string COMMENT '业务日期',
end_franchisee_code string comment  '加盟商code',
end_franchisee_name string comment  '加盟商'
 )
comment '转运直送汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_terminal_tran_direct_delivery_send_sum_dt'
TBLPROPERTIES (
 'discover.partitions' = 'false',
 'parquet.column.index.access' = 'true'
 );
